select * from codes c where c.code_type = 'AddlSetup' and c.valid_code = 'SysSetup'
		

				select c.misc_alpha9 tz, c2.misc_alpha tz_offset
				from codes c
				left outer join codes as c2 on (c2.code_type = 'TIMEZONE' and c2.valid_code = c.misc_alpha9)
				where c.code_type = 'AddlSetup' and c.valid_code = 'SysSetup'
			

			select * from codes c where c.code_type = 'AddlSetup' and c.valid_code = 'SysSetup'
		

				select c.misc_alpha9 tz, c2.misc_alpha tz_offset
				from codes c
				left outer join codes as c2 on (c2.code_type = 'TIMEZONE' and c2.valid_code = c.misc_alpha9)
				where c.code_type = 'AddlSetup' and c.valid_code = 'SysSetup'
			

		SELECT dist_name FROM fasinfo
	

			select top 1 * from codes
		

		SELECT mt.meeting_type, mt.descr, c.long_descr notify_public
		FROM meeting_type mt
		LEFT OUTER JOIN codes c ON (c.code_type = 'MTG_MSG' AND c.valid_code = mt.meeting_type)
		WHERE mt.show_public = 'Y'
			
		ORDER BY mt.descr
	

	SELECT notify_public FROM meetingTypes WHERE notify_public = 'Y'

		select text_value1 notify_public_contact, long_descr confLink
		from codes
		where codes.code_type = 'AddlSetup' and codes.valid_code = 'EmailSub'
	

	SELECT * from codes WHERE code_type = 'AddlSetup' AND valid_code = 'SysSetup'

	SELECT c.*,
	 	c.misc_alpha6 subscribe_tab, c.misc_alpha7 officials_tab, c.misc_alpha8 ordinance_tab, c.misc_alpha9 resolution_tab,
	 	c.misc_alpha11 voting_tab, c.misc_alpha12 useTabs, c.datasortOrder noOfMonths, c.loc_code ApplyTab,
	 	c.misc_alpha14 otherTab, c.misc_alpha15 oth_tab_descr, c1.misc_alpha3 other_doc_type,
 		c1.misc_alpha tab_color, c1.misc_alpha2 time_period, c1.misc_alpha4 sort_res_ord,
 		c1.misc_alpha5 ord_tab_descr, c1.misc_alpha6 res_tab_descr
 	from codes c
    LEFT OUTER JOIN codes c1 ON (c1.code_type = 'AddlSetup' AND c1.valid_code = 'SysSetup3')
	WHERE c.code_type = 'AddlSetup' AND c.valid_code = 'SysSetup2'

		select text_value1 notify_public_contact, long_descr confLink
		from codes
		where codes.code_type = 'AddlSetup' and codes.valid_code = 'EmailSub'

		select valid_code
		from codes
		where codes.code_type = 'MTG_MSG' and codes.misc_alpha15 = 'Y'

	SELECT user_filedir_alias, min_dir_alias, use_minutes, use_agendaquick,
		srch_engine, isys_path, dflt_verity_coll, hart_version, user_defined
	FROM fasinfo

	select fasinfo.*,
	       c3.large_misc_alpha external_prefix, c3.misc_alpha2 active_directory, c3.misc_alpha3 ad_custsfx,
	       c3.loc_code allowExtNotes, c3.misc_alpha4 hostedInstall, c3.descr publTimeout, c3.text_value2 hosted_code
	from fasinfo
	left outer join codes as c3 on (c3.code_type = 'AddlSetup' and c3.valid_code = 'SysSetup')

	select text_value1, misc_alpha public_window, loc_code allowExtNotes
	from codes where code_type = 'AddlSetup' and valid_code = 'SysSetup'

	SELECT MIN(fis_yr) fis_yr FROM fas
	WHERE form_id = 'AGENDA'

	SELECT MAX(fis_yr) fis_yr
	FROM fas
	WHERE form_id = 'AGENDA' AND final_apprvl = 'Y'

	SELECT MIN(coll_name) coll_name FROM verity_collections
	ORDER BY coll_name

	SELECT code_type FROM user_define

	SELECT c.code_type, c.valid_code, c.descr, c.obsolete, c.misc_alpha2, c.descr, c.dataSortOrder sort_order,
		CASE WHEN descr = '' THEN valid_code ELSE descr END AS time_descr
	FROM codes c
	WHERE c.code_type = 'AG TIME'
	
		OR code_type IN ('ud_tb1','ud_pd1','ud_cb1','ud_ta1','ud_ta2','ud_fi1','ud_fi1','ud_cb1','ud_fi3','ud_fi4','ud_fi5','ud_fi6','ud_fi7','ud_fi8','ud_fi9','ud_yn1','ud_fi12','ud_fi13','ud_tb2','ud_fi2','ud_dt1','ud_fims1','ud_fil1','ud_fi3','ud_fis1','ud_tb3','ud_fi4','ud_tb4','ud_tb5','ud_tb6','ud_fi5','ud_fi6','ud_fi7','ud_fi8','ud_fi9','ud_fi10','ud_fi11','ud_fi12','ud_fi13','ud_fi14','ud_fi15','ud_fi16','ud_fi17','ud_fi18','ud_fi19','ud_fi20','ud_fi21','ud_fi22','ud_fi23','ud_dt1','ud_fi14','ud_fi15','ud_dt2','ud_rs1','ud_fi24','ud_fi25','ud_tb7','ud_fi26')
		AND (opt_form_id = '' OR opt_form_id IS NULL)
	

		SELECT m.meeting_dt, m.meeting_name, m.meeting_id, a.form_num as ag_form_num,
			minutes.minutes_published, a.agenda_published,
			a.minutes_doc_name, a.minutes_doc_link,	a.default_doc_dir,
			minutes.default_doc_dir minutes_default_doc_dir,
			a.packet_doc_name, a.packet_published,
			minutes.form_num as min_form_num, minutes.minutes_packet_published,
			minutes.minutes_packet_name,
			ag_links.link_label as ag_link_label, ag_links.link_url as ag_link_url,
			min_links.link_label as min_link_label, min_links.link_url as min_link_url,
			 rel.large_misc_alpha as release_date, agt.meeting_type
		FROM meetings AS m
		INNER JOIN agenda AS a ON ( 
			a.meeting_id = m.meeting_id AND
			(a.agenda_published = 'Y' OR a.packet_published = 'Y')
		)
		LEFT OUTER JOIN minutes ON (
			minutes.meeting_id = m.meeting_id AND
			(minutes.minutes_published = 'Y' OR minutes.minutes_packet_published = 'Y')
		)
		INNER JOIN ag_template AS agt ON (agt.ag_template_id = m.template_id
		
			AND agt.meeting_type IN ('AIR','BOA','SALARY','CCBUDG','CCCSMWS','CCMTG','CCES','CCJWS','CCMTGF','CCSCM','CCSWS','CCWS','DVA','DA','FB','HPC','HOUS','IND','PQ','OSC','PR','PZ','PSPRS','SUS')
		
		)
		LEFT OUTER JOIN codes as rel ON (rel.code_type = 'AddlMtg' AND CAST(rel.valid_code AS INT) = m.meeting_id)
		
		LEFT OUTER JOIN form_links AS ag_links ON (
			ag_links.form_id  = 'AGENDA' AND
			ag_links.form_num = a.form_num AND
			ag_links.link_seq = 1
		)
		LEFT OUTER JOIN form_links AS min_links ON (
			min_links.form_id  = 'MINUTES' AND
			min_links.form_num = minutes.form_num AND
			min_links.rev_num  = minutes.rev_num AND
			min_links.link_seq = 1
		)
		WHERE m.meeting_dt >= ?

		  AND m.meeting_dt <= ?

		ORDER BY m.meeting_dt DESC, m.meeting_name
		

	SELECT menu_label FROM fas_menu WHERE web_page = '../fas/term_report.cfm'

	SELECT * FROM fasinfo

	SELECT use_minutes, use_agendaquick, term_remind_days, c.misc_alpha4 hosted
	FROM fasinfo
	LEFT OUTER JOIN codes c ON (c.code_type = 'AddlSetup' AND c.valid_code = 'SysSetup')

	SELECT * from codes WHERE code_type = 'FORM_ID' AND valid_code = 'AG_MEMO'

	SELECT mt.meeting_type, mt.descr, c.long_descr notify_public, c.misc_alpha15 meetingOfficials
	FROM meeting_type mt
	INNER JOIN codes c ON (c.code_type = 'MTG_MSG' AND c.valid_code = mt.meeting_type)
	WHERE mt.show_public = 'Y' and c.misc_alpha15 = 'Y'
		
	ORDER BY mt.descr

	select tt._rowid tt_rowid, tt.*, codes.valid_code, codes.long_descr, codes.dataSortOrder, mt.descr
	from codes, term_tracker tt
	
		INNER JOIN meeting_type mt ON (mt.meeting_type = tt.meeting_type AND mt.obsolete <> 'Y')
	
	INNER JOIN codes c ON (c.code_type = 'MTG_MSG' AND c.valid_code = tt.meeting_type AND c.misc_alpha15 = 'Y')
	where codes._rowid = tt.code_rowid and	
		  codes.code_type = 'AG_OFF'

	
	      and (tt.term_end >= ? )

	

	order by 
			tt.meeting_type, tt.lname, tt.fname
		

	SELECT * from getRecs

	SELECT * from getRecs

		SELECT mt.meeting_type, mt.descr, c.long_descr notify_public
		FROM meeting_type mt
		LEFT OUTER JOIN codes c ON (c.code_type = 'MTG_MSG' AND c.valid_code = mt.meeting_type)
		WHERE mt.show_public = 'Y' and c.misc_alpha15 = 'Y'
		AND CAST(mt.pdf_header as varchar) <> 'N'
		
	ORDER BY mt.descr

			SELECT min.form_num, m.meeting_dt, m.meeting_name
			from minutes min, meetings m
			where min.meeting_id = m.meeting_id
				AND m.meeting_dt = ?
			ORDER BY meeting_name, meeting_dt
		

		SELECT valid_code, descr, long_descr vote_type, misc_alpha absent FROM codes
		WHERE code_type = 'AG_VOTEOTHER' AND obsolete <> 'Y'
		order by datasortorder
	

						SELECT min.form_num, m.meeting_dt, m.meeting_name
						from minutes min, meetings m
						where min.meeting_id = m.meeting_id
							AND min.minutes_published = 'Y'
							AND m.meeting_dt = ?
						ORDER BY meeting_name, meeting_dt
					

								SELECT a.cont_numbering, a.form_num minutes_form_num, am.form_num fas_form_num, am.ag_item_rowid,
									   ml._rowid ln_rowid, ml._rowid min_ln_rowid, ml.form_num, ml.seq_num,
									   am.ag_item_rowid, ml.ag_level1 chk_level1, ml.ag_level2 chk_level2, ml.ag_level3 chk_level3,
									   ml.ag_level1, ml.ag_level2, ml.ag_level3, ml.ag_level4, ml.disp_level, am.ainumber,
									   as1.sort_seq sort_level1, ml.ag_memo_id, ml.ag_memo_rev, c1.descr ag_time_descr,
									   fas.routing_apprvl fas_routing_apprvl, fas.final_apprvl fas_final_apprvl,
									   aa.item_type, aa.ag_area, ml.ag_subject,
									   c4.misc_alpha2 level_descriptor,
									   c2.misc_alpha7 lvl_text_size, c2.misc_alpha6 dp_level_ai, c3.long_descr px_size, c3.descr pdf_format,
											mt.agmemo_prefix, mt.agmemo_desc, a.disp_ainumber,
									   CASE WHEN am.ainumber = '' then '-1'
										WHEN am.ainumber = '0' then '-1'
										WHEN am.ainumber IS NULL then '-1'
								        ELSE am.ainumber END AS sort_memo2,
									    am.ag_item_rowid,
									   CASE WHEN ml.ag_level2 != '' AND ml.ag_level2 != '0' THEN as2.sort_seq ELSE -1 END AS sort_level2,
									   CASE WHEN ml.ag_level3 != '' AND ml.ag_level3 != '0' THEN as3.sort_seq ELSE -1 END AS sort_level3,
									   CASE WHEN ml.ag_level4 != '' AND ml.ag_level4 != '0' THEN as4.sort_seq ELSE -1 END AS sort_level4,
									   CASE WHEN ml.ag_memo_id IS NOT NULL THEN ml.ag_memo_id ELSE -1 END AS sort_memo,
									   CASE WHEN ml.ag_memo_id IS NOT NULL THEN am.ag_time ELSE ml.ag_time END as ag_time
								FROM minutes_ln ml
								INNER JOIN minutes a ON (a.form_num = ml.form_num AND a.rev_num = ml.rev_num)

								LEFT OUTER JOIN ag_memo AS am ON (am.form_num = ml.ag_memo_id AND am.rev_num = ml.ag_memo_rev)
								LEFT OUTER JOIN ag_template AS agt ON (agt.ag_template_id = a.ag_template_id)
								LEFT OUTER JOIN meeting_type AS mt ON (mt.meeting_type = agt.meeting_type)
								LEFT OUTER JOIN fas ON (fas.form_id = 'AG_MEMO' AND fas.form_num = am.form_num AND fas.rev_num = am.rev_num)
								
								LEFT OUTER JOIN ag_item AS ai ON (ai._rowid = am.ag_item_rowid)
								
								LEFT OUTER JOIN agenda_ln AS al ON (al.ag_memo_id = am.form_num AND al.ag_memo_rev = am.rev_num)
								LEFT OUTER JOIN ag_area AS aa ON (aa.meeting_type = agt.meeting_type AND aa.ag_area = ml.ag_area)          
								LEFT OUTER JOIN codes AS c1 ON (c1.code_type = 'AG TIME' and c1.valid_code = am.ag_time)
								LEFT OUTER JOIN alpha_sort AS as1 ON (as1.alpha_value = ml.ag_level1 AND CAST(as1.alpha_value AS binary(8)) = CAST(ml.ag_level1 AS binary(8)))
								LEFT OUTER JOIN alpha_sort AS as2 ON (as2.alpha_value = ml.ag_level2 AND CAST(as2.alpha_value AS binary(8)) = CAST(ml.ag_level2 AS binary(8)))
								LEFT OUTER JOIN alpha_sort AS as3 ON (as3.alpha_value = ml.ag_level3 AND CAST(as3.alpha_value AS binary(8)) = CAST(ml.ag_level3 AS binary(8)))
								LEFT OUTER JOIN alpha_sort AS as4 ON (as4.alpha_value = ml.ag_level4 AND CAST(as4.alpha_value AS binary(8)) = CAST(ml.ag_level4 AS binary(8)))
								LEFT OUTER JOIN codes AS c2 ON (c2.code_type = 'AddlMtg' and CAST(c2.valid_code AS INT) = a.meeting_id)
								LEFT OUTER JOIN codes AS c3 ON (c3.code_type = 'AG_FONT' and c3.valid_code = a.text_size)
								LEFT OUTER JOIN codes AS c4 ON (c4.code_type = 'MTG_MSG' and c4.valid_code = mt.meeting_type)
								WHERE ml.form_num = 973
								ORDER BY sort_level1, sort_level2, sort_level3, sort_level4, sort_memo2, sort_memo, ln_rowid
							

							SELECT DISTINCT ag_area, item_type FROM getMinLines WHERE item_type = 'Y'
						

							SELECT mlv.form_num, ml.form_num minutes_form_num, ml._rowid min_ln_rowid,
									mlv.valid_code, mlv.motion_seq, mlv.seq_num, mlv.motion_rowid,
									ml.ag_memo_id, ml.ag_memo_rev, ml.ag_subject, mlm.motion_status, mlm.ln_rowid,
									c1.descr voteDescr, vote, c.descr, c1.long_descr vote_type, c1.misc_alpha abs_vote, tt.lname
							from minutes_ln_vote mlv
							INNER JOIN minutes_ln ml ON (ml._rowid = mlv.ln_rowid)
							INNER JOIN minutes_ln_motion mlm ON (mlm.ln_rowid = mlv.ln_rowid AND mlm.motion_seq = mlv.motion_seq)
							INNER JOIN codes c1 ON (c1.code_type = 'AG_VOTEOTHER' AND c1.valid_code = mlv.vote)
						
							LEFT OUTER JOIN codes c ON (c.code_type = 'AG_OFF' AND c.valid_code = mlv.valid_code)
							LEFT OUTER JOIN term_tracker tt ON (tt.code_rowid = c._rowid)
							LEFT OUTER JOIN codes c2 ON (c2.code_type = 'AG_OFF' AND c2.descr = tt.fname + ' ' + tt.lname and
									c2.valid_code = mlv.valid_code AND
									c2.large_misc_alpha = tt.meeting_type)
						    INNER JOIN minutes_roll mr ON (mr.form_num = mlv.form_num AND mr.name = c.descr AND c.large_misc_alpha = tt.meeting_type)
						
							WHERE mlv.form_num = 973 
								AND (mlv.valid_code = c.valid_code OR c2.large_misc_alpha = c.large_misc_alpha)
							
							order by mlv.form_num, mlv.ln_rowid, mlv.motion_seq, mlv.seq_num, mlv.valid_code
						

						SELECT voteDescr, count(voteDescr) voteCount
						FROM getAllVotes group by voteDescr
					

							SELECT DISTINCT lname, valid_code, descr from getAllVotes
							WHERE form_num = 973
							order by lname
						

								SELECT a.cont_numbering, a.form_num minutes_form_num, am.form_num fas_form_num, am.ag_item_rowid,
									   ml._rowid ln_rowid, ml._rowid min_ln_rowid, ml.form_num, ml.seq_num,
									   am.ag_item_rowid, ml.ag_level1 chk_level1, ml.ag_level2 chk_level2, ml.ag_level3 chk_level3,
									   ml.ag_level1, ml.ag_level2, ml.ag_level3, ml.ag_level4, ml.disp_level, am.ainumber,
									   as1.sort_seq sort_level1, ml.ag_memo_id, ml.ag_memo_rev, c1.descr ag_time_descr,
									   fas.routing_apprvl fas_routing_apprvl, fas.final_apprvl fas_final_apprvl,
									   aa.item_type, aa.ag_area, ml.ag_subject,
									   c4.misc_alpha2 level_descriptor,
									   c2.misc_alpha7 lvl_text_size, c2.misc_alpha6 dp_level_ai, c3.long_descr px_size, c3.descr pdf_format,
											mt.agmemo_prefix, mt.agmemo_desc, a.disp_ainumber,
									   CASE WHEN am.ainumber = '' then '-1'
										WHEN am.ainumber = '0' then '-1'
										WHEN am.ainumber IS NULL then '-1'
								        ELSE am.ainumber END AS sort_memo2,
									    am.ag_item_rowid,
									   CASE WHEN ml.ag_level2 != '' AND ml.ag_level2 != '0' THEN as2.sort_seq ELSE -1 END AS sort_level2,
									   CASE WHEN ml.ag_level3 != '' AND ml.ag_level3 != '0' THEN as3.sort_seq ELSE -1 END AS sort_level3,
									   CASE WHEN ml.ag_level4 != '' AND ml.ag_level4 != '0' THEN as4.sort_seq ELSE -1 END AS sort_level4,
									   CASE WHEN ml.ag_memo_id IS NOT NULL THEN ml.ag_memo_id ELSE -1 END AS sort_memo,
									   CASE WHEN ml.ag_memo_id IS NOT NULL THEN am.ag_time ELSE ml.ag_time END as ag_time
								FROM minutes_ln ml
								INNER JOIN minutes a ON (a.form_num = ml.form_num AND a.rev_num = ml.rev_num)

								LEFT OUTER JOIN ag_memo AS am ON (am.form_num = ml.ag_memo_id AND am.rev_num = ml.ag_memo_rev)
								LEFT OUTER JOIN ag_template AS agt ON (agt.ag_template_id = a.ag_template_id)
								LEFT OUTER JOIN meeting_type AS mt ON (mt.meeting_type = agt.meeting_type)
								LEFT OUTER JOIN fas ON (fas.form_id = 'AG_MEMO' AND fas.form_num = am.form_num AND fas.rev_num = am.rev_num)
								
								LEFT OUTER JOIN ag_item AS ai ON (ai._rowid = am.ag_item_rowid)
								
								LEFT OUTER JOIN agenda_ln AS al ON (al.ag_memo_id = am.form_num AND al.ag_memo_rev = am.rev_num)
								LEFT OUTER JOIN ag_area AS aa ON (aa.meeting_type = agt.meeting_type AND aa.ag_area = ml.ag_area)          
								LEFT OUTER JOIN codes AS c1 ON (c1.code_type = 'AG TIME' and c1.valid_code = am.ag_time)
								LEFT OUTER JOIN alpha_sort AS as1 ON (as1.alpha_value = ml.ag_level1 AND CAST(as1.alpha_value AS binary(8)) = CAST(ml.ag_level1 AS binary(8)))
								LEFT OUTER JOIN alpha_sort AS as2 ON (as2.alpha_value = ml.ag_level2 AND CAST(as2.alpha_value AS binary(8)) = CAST(ml.ag_level2 AS binary(8)))
								LEFT OUTER JOIN alpha_sort AS as3 ON (as3.alpha_value = ml.ag_level3 AND CAST(as3.alpha_value AS binary(8)) = CAST(ml.ag_level3 AS binary(8)))
								LEFT OUTER JOIN alpha_sort AS as4 ON (as4.alpha_value = ml.ag_level4 AND CAST(as4.alpha_value AS binary(8)) = CAST(ml.ag_level4 AS binary(8)))
								LEFT OUTER JOIN codes AS c2 ON (c2.code_type = 'AddlMtg' and CAST(c2.valid_code AS INT) = a.meeting_id)
								LEFT OUTER JOIN codes AS c3 ON (c3.code_type = 'AG_FONT' and c3.valid_code = a.text_size)
								LEFT OUTER JOIN codes AS c4 ON (c4.code_type = 'MTG_MSG' and c4.valid_code = mt.meeting_type)
								WHERE ml.form_num = 974
								ORDER BY sort_level1, sort_level2, sort_level3, sort_level4, sort_memo2, sort_memo, ln_rowid
							

							SELECT DISTINCT ag_area, item_type FROM getMinLines WHERE item_type = 'Y'
						

							SELECT mlv.form_num, ml.form_num minutes_form_num, ml._rowid min_ln_rowid,
									mlv.valid_code, mlv.motion_seq, mlv.seq_num, mlv.motion_rowid,
									ml.ag_memo_id, ml.ag_memo_rev, ml.ag_subject, mlm.motion_status, mlm.ln_rowid,
									c1.descr voteDescr, vote, c.descr, c1.long_descr vote_type, c1.misc_alpha abs_vote, tt.lname
							from minutes_ln_vote mlv
							INNER JOIN minutes_ln ml ON (ml._rowid = mlv.ln_rowid)
							INNER JOIN minutes_ln_motion mlm ON (mlm.ln_rowid = mlv.ln_rowid AND mlm.motion_seq = mlv.motion_seq)
							INNER JOIN codes c1 ON (c1.code_type = 'AG_VOTEOTHER' AND c1.valid_code = mlv.vote)
						
							LEFT OUTER JOIN codes c ON (c.code_type = 'AG_OFF' AND c.valid_code = mlv.valid_code)
							LEFT OUTER JOIN term_tracker tt ON (tt.code_rowid = c._rowid)
							LEFT OUTER JOIN codes c2 ON (c2.code_type = 'AG_OFF' AND c2.descr = tt.fname + ' ' + tt.lname and
									c2.valid_code = mlv.valid_code AND
									c2.large_misc_alpha = tt.meeting_type)
						    INNER JOIN minutes_roll mr ON (mr.form_num = mlv.form_num AND mr.name = c.descr AND c.large_misc_alpha = tt.meeting_type)
						
							WHERE mlv.form_num = 974 
								AND (mlv.valid_code = c.valid_code OR c2.large_misc_alpha = c.large_misc_alpha)
							
							order by mlv.form_num, mlv.ln_rowid, mlv.motion_seq, mlv.seq_num, mlv.valid_code
						

						SELECT voteDescr, count(voteDescr) voteCount
						FROM getAllVotes group by voteDescr
					

							SELECT DISTINCT lname, valid_code, descr from getAllVotes
							WHERE form_num = 974
							order by lname
						

								SELECT a.cont_numbering, a.form_num minutes_form_num, am.form_num fas_form_num, am.ag_item_rowid,
									   ml._rowid ln_rowid, ml._rowid min_ln_rowid, ml.form_num, ml.seq_num,
									   am.ag_item_rowid, ml.ag_level1 chk_level1, ml.ag_level2 chk_level2, ml.ag_level3 chk_level3,
									   ml.ag_level1, ml.ag_level2, ml.ag_level3, ml.ag_level4, ml.disp_level, am.ainumber,
									   as1.sort_seq sort_level1, ml.ag_memo_id, ml.ag_memo_rev, c1.descr ag_time_descr,
									   fas.routing_apprvl fas_routing_apprvl, fas.final_apprvl fas_final_apprvl,
									   aa.item_type, aa.ag_area, ml.ag_subject,
									   c4.misc_alpha2 level_descriptor,
									   c2.misc_alpha7 lvl_text_size, c2.misc_alpha6 dp_level_ai, c3.long_descr px_size, c3.descr pdf_format,
											mt.agmemo_prefix, mt.agmemo_desc, a.disp_ainumber,
									   CASE WHEN am.ainumber = '' then '-1'
										WHEN am.ainumber = '0' then '-1'
										WHEN am.ainumber IS NULL then '-1'
								        ELSE am.ainumber END AS sort_memo2,
									    am.ag_item_rowid,
									   CASE WHEN ml.ag_level2 != '' AND ml.ag_level2 != '0' THEN as2.sort_seq ELSE -1 END AS sort_level2,
									   CASE WHEN ml.ag_level3 != '' AND ml.ag_level3 != '0' THEN as3.sort_seq ELSE -1 END AS sort_level3,
									   CASE WHEN ml.ag_level4 != '' AND ml.ag_level4 != '0' THEN as4.sort_seq ELSE -1 END AS sort_level4,
									   CASE WHEN ml.ag_memo_id IS NOT NULL THEN ml.ag_memo_id ELSE -1 END AS sort_memo,
									   CASE WHEN ml.ag_memo_id IS NOT NULL THEN am.ag_time ELSE ml.ag_time END as ag_time
								FROM minutes_ln ml
								INNER JOIN minutes a ON (a.form_num = ml.form_num AND a.rev_num = ml.rev_num)

								LEFT OUTER JOIN ag_memo AS am ON (am.form_num = ml.ag_memo_id AND am.rev_num = ml.ag_memo_rev)
								LEFT OUTER JOIN ag_template AS agt ON (agt.ag_template_id = a.ag_template_id)
								LEFT OUTER JOIN meeting_type AS mt ON (mt.meeting_type = agt.meeting_type)
								LEFT OUTER JOIN fas ON (fas.form_id = 'AG_MEMO' AND fas.form_num = am.form_num AND fas.rev_num = am.rev_num)
								
								LEFT OUTER JOIN ag_item AS ai ON (ai._rowid = am.ag_item_rowid)
								
								LEFT OUTER JOIN agenda_ln AS al ON (al.ag_memo_id = am.form_num AND al.ag_memo_rev = am.rev_num)
								LEFT OUTER JOIN ag_area AS aa ON (aa.meeting_type = agt.meeting_type AND aa.ag_area = ml.ag_area)          
								LEFT OUTER JOIN codes AS c1 ON (c1.code_type = 'AG TIME' and c1.valid_code = am.ag_time)
								LEFT OUTER JOIN alpha_sort AS as1 ON (as1.alpha_value = ml.ag_level1 AND CAST(as1.alpha_value AS binary(8)) = CAST(ml.ag_level1 AS binary(8)))
								LEFT OUTER JOIN alpha_sort AS as2 ON (as2.alpha_value = ml.ag_level2 AND CAST(as2.alpha_value AS binary(8)) = CAST(ml.ag_level2 AS binary(8)))
								LEFT OUTER JOIN alpha_sort AS as3 ON (as3.alpha_value = ml.ag_level3 AND CAST(as3.alpha_value AS binary(8)) = CAST(ml.ag_level3 AS binary(8)))
								LEFT OUTER JOIN alpha_sort AS as4 ON (as4.alpha_value = ml.ag_level4 AND CAST(as4.alpha_value AS binary(8)) = CAST(ml.ag_level4 AS binary(8)))
								LEFT OUTER JOIN codes AS c2 ON (c2.code_type = 'AddlMtg' and CAST(c2.valid_code AS INT) = a.meeting_id)
								LEFT OUTER JOIN codes AS c3 ON (c3.code_type = 'AG_FONT' and c3.valid_code = a.text_size)
								LEFT OUTER JOIN codes AS c4 ON (c4.code_type = 'MTG_MSG' and c4.valid_code = mt.meeting_type)
								WHERE ml.form_num = 970
								ORDER BY sort_level1, sort_level2, sort_level3, sort_level4, sort_memo2, sort_memo, ln_rowid
							

							SELECT DISTINCT ag_area, item_type FROM getMinLines WHERE item_type = 'Y'
						

							SELECT mlv.form_num, ml.form_num minutes_form_num, ml._rowid min_ln_rowid,
									mlv.valid_code, mlv.motion_seq, mlv.seq_num, mlv.motion_rowid,
									ml.ag_memo_id, ml.ag_memo_rev, ml.ag_subject, mlm.motion_status, mlm.ln_rowid,
									c1.descr voteDescr, vote, c.descr, c1.long_descr vote_type, c1.misc_alpha abs_vote, tt.lname
							from minutes_ln_vote mlv
							INNER JOIN minutes_ln ml ON (ml._rowid = mlv.ln_rowid)
							INNER JOIN minutes_ln_motion mlm ON (mlm.ln_rowid = mlv.ln_rowid AND mlm.motion_seq = mlv.motion_seq)
							INNER JOIN codes c1 ON (c1.code_type = 'AG_VOTEOTHER' AND c1.valid_code = mlv.vote)
						
							LEFT OUTER JOIN codes c ON (c.code_type = 'AG_OFF' AND c.valid_code = mlv.valid_code)
							LEFT OUTER JOIN term_tracker tt ON (tt.code_rowid = c._rowid)
							LEFT OUTER JOIN codes c2 ON (c2.code_type = 'AG_OFF' AND c2.descr = tt.fname + ' ' + tt.lname and
									c2.valid_code = mlv.valid_code AND
									c2.large_misc_alpha = tt.meeting_type)
						    INNER JOIN minutes_roll mr ON (mr.form_num = mlv.form_num AND mr.name = c.descr AND c.large_misc_alpha = tt.meeting_type)
						
							WHERE mlv.form_num = 970 
								AND (mlv.valid_code = c.valid_code OR c2.large_misc_alpha = c.large_misc_alpha)
							
							order by mlv.form_num, mlv.ln_rowid, mlv.motion_seq, mlv.seq_num, mlv.valid_code
						

						SELECT voteDescr, count(voteDescr) voteCount
						FROM getAllVotes group by voteDescr
					

		SELECT * from getVoteTypes WHERE getVoteTypes.descr = 'ABSENT'
	

		SELECT * from getVoteTypes WHERE getVoteTypes.descr = 'AYE'
	

		SELECT * from getVoteTypes WHERE getVoteTypes.descr = 'NAY'
	

							SELECT DISTINCT lname, valid_code, descr from getAllVotes
							WHERE form_num = 970
							order by lname
						

										SELECT * from getAllVotes WHERE ln_rowid = 20602 

										SELECT _rowid mtn_rowid, * from minutes_ln_motion
										WHERE form_num = 970 AND
											ln_rowid = 20602 

		SELECT meeting_id FROM minutes WHERE form_num = 970 

		SELECT 'Alpha','Alpha','Alpha','Alpha', a.ag_punct
		FROM meetings, agenda a
		WHERE meetings.meeting_id = ? AND
		      a.meeting_id = meetings.meeting_id
		

					SELECT * from getMinLines
					WHERE ln_rowid = 20602 

										SELECT * from getAllVotes WHERE ln_rowid = 20604 

										SELECT _rowid mtn_rowid, * from minutes_ln_motion
										WHERE form_num = 970 AND
											ln_rowid = 20604 

		SELECT meeting_id FROM minutes WHERE form_num = 970 

		SELECT 'Alpha','Alpha','Alpha','Alpha', a.ag_punct
		FROM meetings, agenda a
		WHERE meetings.meeting_id = ? AND
		      a.meeting_id = meetings.meeting_id
		

					SELECT * from getMinLines
					WHERE ln_rowid = 20604 

					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 970
					AND a.ag_level1 = '1'
					AND (a.ag_level2 = '' OR a.ag_level2 IS NULL)
					AND (a.ag_level3 = '' OR a.ag_level3 IS NULL)
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				

					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 970
					AND a.ag_level1 = '1'
					AND a.ag_level2 = ''
					AND (a.ag_level3 = '' OR a.ag_level3 IS NULL)
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				

					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 970
					AND a.ag_level1 = '1'
					AND a.ag_level2 = ''
					AND a.ag_level3 = ''
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				

										SELECT * from getAllVotes WHERE ln_rowid = 20617 

										SELECT _rowid mtn_rowid, * from minutes_ln_motion
										WHERE form_num = 970 AND
											ln_rowid = 20617 

		SELECT meeting_id FROM minutes WHERE form_num = 970 

		SELECT 'Alpha','Alpha','Alpha','Alpha', a.ag_punct
		FROM meetings, agenda a
		WHERE meetings.meeting_id = ? AND
		      a.meeting_id = meetings.meeting_id
		

					SELECT * from getMinLines
					WHERE ln_rowid = 20617 

										SELECT * from getAllVotes WHERE ln_rowid = 20603 

										SELECT _rowid mtn_rowid, * from minutes_ln_motion
										WHERE form_num = 970 AND
											ln_rowid = 20603 

		SELECT meeting_id FROM minutes WHERE form_num = 970 

		SELECT 'Alpha','Alpha','Alpha','Alpha', a.ag_punct
		FROM meetings, agenda a
		WHERE meetings.meeting_id = ? AND
		      a.meeting_id = meetings.meeting_id
		

					SELECT * from getMinLines
					WHERE ln_rowid = 20603 

					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 970
					AND a.ag_level1 = '2'
					AND (a.ag_level2 = '' OR a.ag_level2 IS NULL)
					AND (a.ag_level3 = '' OR a.ag_level3 IS NULL)
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				

					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 970
					AND a.ag_level1 = '2'
					AND a.ag_level2 = ''
					AND (a.ag_level3 = '' OR a.ag_level3 IS NULL)
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				

					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 970
					AND a.ag_level1 = '2'
					AND a.ag_level2 = ''
					AND a.ag_level3 = ''
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				

										SELECT * from getAllVotes WHERE ln_rowid = 20613 

										SELECT _rowid mtn_rowid, * from minutes_ln_motion
										WHERE form_num = 970 AND
											ln_rowid = 20613 

		SELECT meeting_id FROM minutes WHERE form_num = 970 

		SELECT 'Alpha','Alpha','Alpha','Alpha', a.ag_punct
		FROM meetings, agenda a
		WHERE meetings.meeting_id = ? AND
		      a.meeting_id = meetings.meeting_id
		

					SELECT * from getMinLines
					WHERE ln_rowid = 20613 

					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 970
					AND a.ag_level1 = '3'
					AND (a.ag_level2 = '' OR a.ag_level2 IS NULL)
					AND (a.ag_level3 = '' OR a.ag_level3 IS NULL)
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				

					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 970
					AND a.ag_level1 = '3'
					AND a.ag_level2 = ''
					AND (a.ag_level3 = '' OR a.ag_level3 IS NULL)
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				

					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 970
					AND a.ag_level1 = '3'
					AND a.ag_level2 = ''
					AND a.ag_level3 = ''
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				

										SELECT * from getAllVotes WHERE ln_rowid = 20607 

										SELECT _rowid mtn_rowid, * from minutes_ln_motion
										WHERE form_num = 970 AND
											ln_rowid = 20607 

		SELECT meeting_id FROM minutes WHERE form_num = 970 

		SELECT 'Alpha','Alpha','Alpha','Alpha', a.ag_punct
		FROM meetings, agenda a
		WHERE meetings.meeting_id = ? AND
		      a.meeting_id = meetings.meeting_id
		

					SELECT * from getMinLines
					WHERE ln_rowid = 20607 

					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 970
					AND a.ag_level1 = '4'
					AND (a.ag_level2 = '' OR a.ag_level2 IS NULL)
					AND (a.ag_level3 = '' OR a.ag_level3 IS NULL)
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				

					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 970
					AND a.ag_level1 = '4'
					AND a.ag_level2 = ''
					AND (a.ag_level3 = '' OR a.ag_level3 IS NULL)
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				

					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 970
					AND a.ag_level1 = '4'
					AND a.ag_level2 = ''
					AND a.ag_level3 = ''
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				

										SELECT * from getAllVotes WHERE ln_rowid = 20611 

										SELECT _rowid mtn_rowid, * from minutes_ln_motion
										WHERE form_num = 970 AND
											ln_rowid = 20611 

		SELECT meeting_id FROM minutes WHERE form_num = 970 

		SELECT 'Alpha','Alpha','Alpha','Alpha', a.ag_punct
		FROM meetings, agenda a
		WHERE meetings.meeting_id = ? AND
		      a.meeting_id = meetings.meeting_id
		

					SELECT * from getMinLines
					WHERE ln_rowid = 20611 

					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 970
					AND a.ag_level1 = '5'
					AND (a.ag_level2 = '' OR a.ag_level2 IS NULL)
					AND (a.ag_level3 = '' OR a.ag_level3 IS NULL)
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				

					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 970
					AND a.ag_level1 = '5'
					AND a.ag_level2 = ''
					AND (a.ag_level3 = '' OR a.ag_level3 IS NULL)
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				

					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 970
					AND a.ag_level1 = '5'
					AND a.ag_level2 = ''
					AND a.ag_level3 = ''
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				

										SELECT * from getAllVotes WHERE ln_rowid = 20605 

										SELECT _rowid mtn_rowid, * from minutes_ln_motion
										WHERE form_num = 970 AND
											ln_rowid = 20605 

		SELECT meeting_id FROM minutes WHERE form_num = 970 

		SELECT 'Alpha','Alpha','Alpha','Alpha', a.ag_punct
		FROM meetings, agenda a
		WHERE meetings.meeting_id = ? AND
		      a.meeting_id = meetings.meeting_id
		

					SELECT * from getMinLines
					WHERE ln_rowid = 20605 

					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 970
					AND a.ag_level1 = '6'
					AND (a.ag_level2 = '' OR a.ag_level2 IS NULL)
					AND (a.ag_level3 = '' OR a.ag_level3 IS NULL)
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				

					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 970
					AND a.ag_level1 = '6'
					AND a.ag_level2 = ''
					AND (a.ag_level3 = '' OR a.ag_level3 IS NULL)
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				

					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 970
					AND a.ag_level1 = '6'
					AND a.ag_level2 = ''
					AND a.ag_level3 = ''
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				

										SELECT * from getAllVotes WHERE ln_rowid = 20614 

										SELECT _rowid mtn_rowid, * from minutes_ln_motion
										WHERE form_num = 970 AND
											ln_rowid = 20614 

		SELECT meeting_id FROM minutes WHERE form_num = 970 

		SELECT 'Alpha','Alpha','Alpha','Alpha', a.ag_punct
		FROM meetings, agenda a
		WHERE meetings.meeting_id = ? AND
		      a.meeting_id = meetings.meeting_id
		

					SELECT * from getMinLines
					WHERE ln_rowid = 20614 

					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 970
					AND a.ag_level1 = '6'
					AND (a.ag_level2 = '' OR a.ag_level2 IS NULL)
					AND (a.ag_level3 = '' OR a.ag_level3 IS NULL)
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				

					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 970
					AND a.ag_level1 = '6'
					AND a.ag_level2 = 'A'
					AND (a.ag_level3 = '' OR a.ag_level3 IS NULL)
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				

					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 970
					AND a.ag_level1 = '6'
					AND a.ag_level2 = 'A'
					AND a.ag_level3 = ''
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				

										SELECT * from getAllVotes WHERE ln_rowid = 20606 

										SELECT _rowid mtn_rowid, * from minutes_ln_motion
										WHERE form_num = 970 AND
											ln_rowid = 20606 

		SELECT meeting_id FROM minutes WHERE form_num = 970 

		SELECT 'Alpha','Alpha','Alpha','Alpha', a.ag_punct
		FROM meetings, agenda a
		WHERE meetings.meeting_id = ? AND
		      a.meeting_id = meetings.meeting_id
		

					SELECT * from getMinLines
					WHERE ln_rowid = 20606 

					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 970
					AND a.ag_level1 = '7'
					AND (a.ag_level2 = '' OR a.ag_level2 IS NULL)
					AND (a.ag_level3 = '' OR a.ag_level3 IS NULL)
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				

					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 970
					AND a.ag_level1 = '7'
					AND a.ag_level2 = ''
					AND (a.ag_level3 = '' OR a.ag_level3 IS NULL)
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				

					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 970
					AND a.ag_level1 = '7'
					AND a.ag_level2 = ''
					AND a.ag_level3 = ''
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				

										SELECT * from getAllVotes WHERE ln_rowid = 20615 

										SELECT _rowid mtn_rowid, * from minutes_ln_motion
										WHERE form_num = 970 AND
											ln_rowid = 20615 

		SELECT meeting_id FROM minutes WHERE form_num = 970 

		SELECT 'Alpha','Alpha','Alpha','Alpha', a.ag_punct
		FROM meetings, agenda a
		WHERE meetings.meeting_id = ? AND
		      a.meeting_id = meetings.meeting_id
		

					SELECT * from getMinLines
					WHERE ln_rowid = 20615 

					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 970
					AND a.ag_level1 = '7'
					AND (a.ag_level2 = '' OR a.ag_level2 IS NULL)
					AND (a.ag_level3 = '' OR a.ag_level3 IS NULL)
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				

					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 970
					AND a.ag_level1 = '7'
					AND a.ag_level2 = 'A'
					AND (a.ag_level3 = '' OR a.ag_level3 IS NULL)
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				

					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 970
					AND a.ag_level1 = '7'
					AND a.ag_level2 = 'A'
					AND a.ag_level3 = ''
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				

										SELECT * from getAllVotes WHERE ln_rowid = 20610 

										SELECT _rowid mtn_rowid, * from minutes_ln_motion
										WHERE form_num = 970 AND
											ln_rowid = 20610 

		SELECT meeting_id FROM minutes WHERE form_num = 970 

		SELECT 'Alpha','Alpha','Alpha','Alpha', a.ag_punct
		FROM meetings, agenda a
		WHERE meetings.meeting_id = ? AND
		      a.meeting_id = meetings.meeting_id
		

					SELECT * from getMinLines
					WHERE ln_rowid = 20610 

					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 970
					AND a.ag_level1 = '8'
					AND (a.ag_level2 = '' OR a.ag_level2 IS NULL)
					AND (a.ag_level3 = '' OR a.ag_level3 IS NULL)
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				

					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 970
					AND a.ag_level1 = '8'
					AND a.ag_level2 = ''
					AND (a.ag_level3 = '' OR a.ag_level3 IS NULL)
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				

					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 970
					AND a.ag_level1 = '8'
					AND a.ag_level2 = ''
					AND a.ag_level3 = ''
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				

										SELECT * from getAllVotes WHERE ln_rowid = 20612 

										SELECT _rowid mtn_rowid, * from minutes_ln_motion
										WHERE form_num = 970 AND
											ln_rowid = 20612 

		SELECT meeting_id FROM minutes WHERE form_num = 970 

		SELECT 'Alpha','Alpha','Alpha','Alpha', a.ag_punct
		FROM meetings, agenda a
		WHERE meetings.meeting_id = ? AND
		      a.meeting_id = meetings.meeting_id
		

					SELECT * from getMinLines
					WHERE ln_rowid = 20612 

					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 970
					AND a.ag_level1 = '8'
					AND (a.ag_level2 = '' OR a.ag_level2 IS NULL)
					AND (a.ag_level3 = '' OR a.ag_level3 IS NULL)
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				

					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 970
					AND a.ag_level1 = '8'
					AND a.ag_level2 = 'A'
					AND (a.ag_level3 = '' OR a.ag_level3 IS NULL)
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				

					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 970
					AND a.ag_level1 = '8'
					AND a.ag_level2 = 'A'
					AND a.ag_level3 = ''
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				

										SELECT * from getAllVotes WHERE ln_rowid = 20616 

										SELECT _rowid mtn_rowid, * from minutes_ln_motion
										WHERE form_num = 970 AND
											ln_rowid = 20616 

		SELECT meeting_id FROM minutes WHERE form_num = 970 

		SELECT 'Alpha','Alpha','Alpha','Alpha', a.ag_punct
		FROM meetings, agenda a
		WHERE meetings.meeting_id = ? AND
		      a.meeting_id = meetings.meeting_id
		

					SELECT * from getMinLines
					WHERE ln_rowid = 20616 

					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 970
					AND a.ag_level1 = '8'
					AND (a.ag_level2 = '' OR a.ag_level2 IS NULL)
					AND (a.ag_level3 = '' OR a.ag_level3 IS NULL)
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				

					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 970
					AND a.ag_level1 = '8'
					AND a.ag_level2 = 'A'
					AND (a.ag_level3 = '' OR a.ag_level3 IS NULL)
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				

					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 970
					AND a.ag_level1 = '8'
					AND a.ag_level2 = 'A'
					AND a.ag_level3 = '1'
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				

										SELECT * from getAllVotes WHERE ln_rowid = 20608 

										SELECT _rowid mtn_rowid, * from minutes_ln_motion
										WHERE form_num = 970 AND
											ln_rowid = 20608 

		SELECT meeting_id FROM minutes WHERE form_num = 970 

		SELECT 'Alpha','Alpha','Alpha','Alpha', a.ag_punct
		FROM meetings, agenda a
		WHERE meetings.meeting_id = ? AND
		      a.meeting_id = meetings.meeting_id
		

					SELECT * from getMinLines
					WHERE ln_rowid = 20608 

					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 970
					AND a.ag_level1 = '9'
					AND (a.ag_level2 = '' OR a.ag_level2 IS NULL)
					AND (a.ag_level3 = '' OR a.ag_level3 IS NULL)
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				

					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 970
					AND a.ag_level1 = '9'
					AND a.ag_level2 = ''
					AND (a.ag_level3 = '' OR a.ag_level3 IS NULL)
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				

					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 970
					AND a.ag_level1 = '9'
					AND a.ag_level2 = ''
					AND a.ag_level3 = ''
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				

										SELECT * from getAllVotes WHERE ln_rowid = 20609 

										SELECT _rowid mtn_rowid, * from minutes_ln_motion
										WHERE form_num = 970 AND
											ln_rowid = 20609 

		SELECT meeting_id FROM minutes WHERE form_num = 970 

		SELECT 'Alpha','Alpha','Alpha','Alpha', a.ag_punct
		FROM meetings, agenda a
		WHERE meetings.meeting_id = ? AND
		      a.meeting_id = meetings.meeting_id
		

					SELECT * from getMinLines
					WHERE ln_rowid = 20609 

					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 970
					AND a.ag_level1 = '10'
					AND (a.ag_level2 = '' OR a.ag_level2 IS NULL)
					AND (a.ag_level3 = '' OR a.ag_level3 IS NULL)
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				

					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 970
					AND a.ag_level1 = '10'
					AND a.ag_level2 = ''
					AND (a.ag_level3 = '' OR a.ag_level3 IS NULL)
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				

					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 970
					AND a.ag_level1 = '10'
					AND a.ag_level2 = ''
					AND a.ag_level3 = ''
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				

								SELECT a.cont_numbering, a.form_num minutes_form_num, am.form_num fas_form_num, am.ag_item_rowid,
									   ml._rowid ln_rowid, ml._rowid min_ln_rowid, ml.form_num, ml.seq_num,
									   am.ag_item_rowid, ml.ag_level1 chk_level1, ml.ag_level2 chk_level2, ml.ag_level3 chk_level3,
									   ml.ag_level1, ml.ag_level2, ml.ag_level3, ml.ag_level4, ml.disp_level, am.ainumber,
									   as1.sort_seq sort_level1, ml.ag_memo_id, ml.ag_memo_rev, c1.descr ag_time_descr,
									   fas.routing_apprvl fas_routing_apprvl, fas.final_apprvl fas_final_apprvl,
									   aa.item_type, aa.ag_area, ml.ag_subject,
									   c4.misc_alpha2 level_descriptor,
									   c2.misc_alpha7 lvl_text_size, c2.misc_alpha6 dp_level_ai, c3.long_descr px_size, c3.descr pdf_format,
											mt.agmemo_prefix, mt.agmemo_desc, a.disp_ainumber,
									   CASE WHEN am.ainumber = '' then '-1'
										WHEN am.ainumber = '0' then '-1'
										WHEN am.ainumber IS NULL then '-1'
								        ELSE am.ainumber END AS sort_memo2,
									    am.ag_item_rowid,
									   CASE WHEN ml.ag_level2 != '' AND ml.ag_level2 != '0' THEN as2.sort_seq ELSE -1 END AS sort_level2,
									   CASE WHEN ml.ag_level3 != '' AND ml.ag_level3 != '0' THEN as3.sort_seq ELSE -1 END AS sort_level3,
									   CASE WHEN ml.ag_level4 != '' AND ml.ag_level4 != '0' THEN as4.sort_seq ELSE -1 END AS sort_level4,
									   CASE WHEN ml.ag_memo_id IS NOT NULL THEN ml.ag_memo_id ELSE -1 END AS sort_memo,
									   CASE WHEN ml.ag_memo_id IS NOT NULL THEN am.ag_time ELSE ml.ag_time END as ag_time
								FROM minutes_ln ml
								INNER JOIN minutes a ON (a.form_num = ml.form_num AND a.rev_num = ml.rev_num)

								LEFT OUTER JOIN ag_memo AS am ON (am.form_num = ml.ag_memo_id AND am.rev_num = ml.ag_memo_rev)
								LEFT OUTER JOIN ag_template AS agt ON (agt.ag_template_id = a.ag_template_id)
								LEFT OUTER JOIN meeting_type AS mt ON (mt.meeting_type = agt.meeting_type)
								LEFT OUTER JOIN fas ON (fas.form_id = 'AG_MEMO' AND fas.form_num = am.form_num AND fas.rev_num = am.rev_num)
								
								LEFT OUTER JOIN ag_item AS ai ON (ai._rowid = am.ag_item_rowid)
								
								LEFT OUTER JOIN agenda_ln AS al ON (al.ag_memo_id = am.form_num AND al.ag_memo_rev = am.rev_num)
								LEFT OUTER JOIN ag_area AS aa ON (aa.meeting_type = agt.meeting_type AND aa.ag_area = ml.ag_area)          
								LEFT OUTER JOIN codes AS c1 ON (c1.code_type = 'AG TIME' and c1.valid_code = am.ag_time)
								LEFT OUTER JOIN alpha_sort AS as1 ON (as1.alpha_value = ml.ag_level1 AND CAST(as1.alpha_value AS binary(8)) = CAST(ml.ag_level1 AS binary(8)))
								LEFT OUTER JOIN alpha_sort AS as2 ON (as2.alpha_value = ml.ag_level2 AND CAST(as2.alpha_value AS binary(8)) = CAST(ml.ag_level2 AS binary(8)))
								LEFT OUTER JOIN alpha_sort AS as3 ON (as3.alpha_value = ml.ag_level3 AND CAST(as3.alpha_value AS binary(8)) = CAST(ml.ag_level3 AS binary(8)))
								LEFT OUTER JOIN alpha_sort AS as4 ON (as4.alpha_value = ml.ag_level4 AND CAST(as4.alpha_value AS binary(8)) = CAST(ml.ag_level4 AS binary(8)))
								LEFT OUTER JOIN codes AS c2 ON (c2.code_type = 'AddlMtg' and CAST(c2.valid_code AS INT) = a.meeting_id)
								LEFT OUTER JOIN codes AS c3 ON (c3.code_type = 'AG_FONT' and c3.valid_code = a.text_size)
								LEFT OUTER JOIN codes AS c4 ON (c4.code_type = 'MTG_MSG' and c4.valid_code = mt.meeting_type)
								WHERE ml.form_num = 969
								ORDER BY sort_level1, sort_level2, sort_level3, sort_level4, sort_memo2, sort_memo, ln_rowid
							

							SELECT DISTINCT ag_area, item_type FROM getMinLines WHERE item_type = 'Y'
						

							SELECT mlv.form_num, ml.form_num minutes_form_num, ml._rowid min_ln_rowid,
									mlv.valid_code, mlv.motion_seq, mlv.seq_num, mlv.motion_rowid,
									ml.ag_memo_id, ml.ag_memo_rev, ml.ag_subject, mlm.motion_status, mlm.ln_rowid,
									c1.descr voteDescr, vote, c.descr, c1.long_descr vote_type, c1.misc_alpha abs_vote, tt.lname
							from minutes_ln_vote mlv
							INNER JOIN minutes_ln ml ON (ml._rowid = mlv.ln_rowid)
							INNER JOIN minutes_ln_motion mlm ON (mlm.ln_rowid = mlv.ln_rowid AND mlm.motion_seq = mlv.motion_seq)
							INNER JOIN codes c1 ON (c1.code_type = 'AG_VOTEOTHER' AND c1.valid_code = mlv.vote)
						
							LEFT OUTER JOIN codes c ON (c.code_type = 'AG_OFF' AND c.valid_code = mlv.valid_code)
							LEFT OUTER JOIN term_tracker tt ON (tt.code_rowid = c._rowid)
							LEFT OUTER JOIN codes c2 ON (c2.code_type = 'AG_OFF' AND c2.descr = tt.fname + ' ' + tt.lname and
									c2.valid_code = mlv.valid_code AND
									c2.large_misc_alpha = tt.meeting_type)
						    INNER JOIN minutes_roll mr ON (mr.form_num = mlv.form_num AND mr.name = c.descr AND c.large_misc_alpha = tt.meeting_type)
						
							WHERE mlv.form_num = 969 
								AND (mlv.valid_code = c.valid_code OR c2.large_misc_alpha = c.large_misc_alpha)
							
							order by mlv.form_num, mlv.ln_rowid, mlv.motion_seq, mlv.seq_num, mlv.valid_code
						

						SELECT voteDescr, count(voteDescr) voteCount
						FROM getAllVotes group by voteDescr
					

							SELECT DISTINCT lname, valid_code, descr from getAllVotes
							WHERE form_num = 969
							order by lname
						

CGI Variables:
AUTH_PASSWORD=
AUTH_TYPE=
AUTH_USER=
CERT_COOKIE=
CERT_FLAGS=
CERT_ISSUER=
CERT_KEYSIZE=
CERT_SECRETKEYSIZE=
CERT_SERIALNUMBER=
CERT_SERVER_ISSUER=
CERT_SERVER_SUBJECT=
CERT_SUBJECT=
CF_TEMPLATE_PATH=D:\inetpub\PublicPages\officials.cfm
CONTENT_LENGTH=0
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=CGI/1.1
HTTPS=off
HTTPS_KEYSIZE=
HTTPS_SECRETKEYSIZE=
HTTPS_SERVER_ISSUER=
HTTPS_SERVER_SUBJECT=
HTTP_ACCEPT=*/*
HTTP_ACCEPT_ENCODING=
HTTP_ACCEPT_LANGUAGE=
HTTP_CONNECTION=Keep-Alive
HTTP_COOKIE=
HTTP_HOST=10.20.10.48:8555
HTTP_REFERER=
HTTP_URL=//officials.cfm?seq=970&report=MEETDATE&dt=2023-10-18%2000:00:00.0&SSTR=&GET_MONTH=4&LOGIN=&LOC=&DSP=&SUB=&ln=0&FP=&MT=ALL&GET_YEAR=2024&id=&StartRow=1
HTTP_USER_AGENT=Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
LOCAL_ADDR=10.20.10.48
PATH_INFO=
PATH_TRANSLATED=D:\inetpub\PublicPages\officials.cfm
QUERY_STRING=seq=970&report=MEETDATE&dt=2023-10-18%2000:00:00.0&SSTR=&GET_MONTH=4&LOGIN=&LOC=&DSP=&SUB=&ln=0&FP=&MT=ALL&GET_YEAR=2024&id=&StartRow=1
REMOTE_ADDR=10.20.230.5
REMOTE_HOST=10.20.230.5
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/officials.cfm
SERVER_NAME=10.20.10.48
SERVER_PORT=8555
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/10.0
WEB_SERVER_API=

Client Variables:
cfid=9393095
cftoken=704a4a9546e098e-C8216AA0-0235-D9F3-1D0419B3FD70AA37
hitcount=4
lastvisit={ts '2024-04-29 23:12:10'}
timecreated={ts '2024-04-29 23:12:10'}
urltoken=CFID=9393095&CFTOKEN=704a4a9546e098e-C8216AA0-0235-D9F3-1D0419B3FD70AA37

Cookie Variables:
CFID=9393095
CFTOKEN=704a4a9546e098e-C8216AA0-0235-D9F3-1D0419B3FD70AA37

Form Fields:
FROMDATE={ts '2023-04-29 23:12:10'}
FROMVOTEDATE={ts '2023-04-29 23:12:10'}
FROMVOTEYEAR=2023
MODE=
TODATE={ts '2024-04-29 23:12:10'}
TOVOTEDATE={ts '2024-04-29 23:12:10'}

Session Variables:
cfid=9393095
cftoken=704a4a9546e098e-C8216AA0-0235-D9F3-1D0419B3FD70AA37
dbtype=SQLSERVER
dsn=frsRO
extpathprefix=/public/
isexternal=true
logfilepath=d:\logs\
loggedin=false
sessionid=FASPUBLIC_9393095_704a4a9546e098e-C8216AA0-0235-D9F3-1D0419B3FD70AA37
subdir=/public/
tzoffset=0
urltoken=CFID=9393095&CFTOKEN=704a4a9546e098e-C8216AA0-0235-D9F3-1D0419B3FD70AA37

URL Parameters:
DSP=
FP=
GET_MONTH=4
GET_YEAR=2024
LOC=
LOGIN=
MT=ALL
SSTR=
SUB=
StartRow=1
dt=2023-10-18 00:00:00.0
id=
ln=0
report=MEETDATE
seq=970